Now if this calculation becomes too unwieldy to do manually, there is an easier way of calculating duration by using Microsoft Excel. The formula is: =DURATION(settlement, maturity, coupon, yld, frequency, [basis]) The DURATION function uses the following arguments: Settlement (required argument) – This is the settlement date of a given ...